package com.example.binpacking.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.binpacking.model.SubjectView;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

public interface SubjectViewMapper extends BaseMapper<SubjectView> {

    @Select("SELECT * FROM view_interview_subject WHERE loginid = #{loginid} AND finishflag = #{finishflag}")
    Page<SubjectView> selectByIdAndFinishflag(Page<SubjectView> page, @Param("loginid") BigDecimal loginid, @Param("finishflag") BigDecimal finishflag);
}
